AA001
DATE
D
Appointment Date
99/99/99
AA002
LASTNAME
C
Last Name
AA003
COMPANY
Company or Employer
AA004
TYPE
Type of Appointment
!
AA005
TDESCRIP
Type Description
AA006
SUBJECT
Subject of Appointment
AA007
STATUS
Appointment Status
AA008
SDESCRIP
Status Description
AA009
D_DAY
Day of Week
AA010
M_DAY
Full Month Name
EA001
Date of Expense
EA002
Type of Expense
EA003
DESCRIP
Expense Description
EA004
PURPOSE
Purpose of Expense
EA005
PARTY
In the Service Of...
EA006
FULLNAME
Last Name of Person Paid
EA008
AMOUNT
N
Amount of Expense
9999999.99
gv > 0
Amount Must Be Greater ZERO!
EA009
REIMBURS
Reimbursed (Y/N)?
gv = 'Y' .or. gv = 'N'
Enter a Y or N Only!
EA010
DATREIMB
Date Reimbursed
EA011
DIFF
Balance Outstanding
gv >= 0
Amount Must Be Greater Than OR Equal to ZERO!
EA012
AUTO
Automobile Expense (Y/N)?
EA013
MILEAGE
Amount of Travel Mileage
Amount Must Be Greater Than ZERO!
FA001
FA002
EMPLOYER
Company/Employer
FA003
Subject of Follow Up
FA004
CDATE
Date of Initial Contact
FA005
CTYPE
Type of Initial Contact
FA006
CDESCRIP
Description of Contact
FA007
Follow Up Date
FA008
Type of Follow Up
FA009
Description of Follow Up
FA010
Follow Up Status
FA011
NA001
NA002
NA003
BUSCITY
Company/Employer City
NA004
BUSSTATE
Company/Employer State
!!
NA005
BUSZIP
Company/Employer Zip Code
NA006
BPROV
Company/Employer Province
NA007
BUSTYPE
Type of Business
NA008
CUSTOMER
Customer (Y/N)?
NA009
CUSTNUM
Customer Number
!!!-999999-999999
NA010
HOMCITY
Home City
NA011
HOMSTATE
Home State
NA012
HOMZIP
Home Zip Code
NA013
HPROV
Home Province
NA014
AGE
Person's Age
999
NA015
DOB
Person's Date of Birth
NA016
SEX
Person's Sex
gv = 'M' .or. gv = 'F'
Enter M or F Only!
CA001
Date of Communication
CA002
Communicator's Last Name
CA003
CA004
CA005
CA006
CA007
CA008
Person's Home City
CA009
Person's Home State
CA010
Person's Home Zip Code
CA011
Person's Home Province
CA012
Type of Communication
CA013
CA014
FOLLOWUP
Follow Up (Y/N)?
Enter Y or N Only!
CA015
FOLLDATE
CA016
FTYPE
Follow Up Type
CA017
FDESCRIP
Follow Up Description
CA018
Subject of Communication
CA019
COMMENT
Communication Comment
TA001
Task ToDo Date
TA002
TASK
Task To Do
TA003
PRIORITY
Task Priority
9
gv = '1' .or. gv = '2' .or. gv = '3' .or. gv = '4' .or. gv = '5'
Priority Must be a Number From 1 to 5 Only!
TA004
DONE
Task Completed (Y/N)?
TA005
WHENDONE
Task Completion Date
TA006
DAYS
Number of Days to Complete
99999
IA001
Invoice/Transaction Date
IA002
TRANSNUM
Transaction Number
IA003
Client Number
IA004
Client's Last Name
IA005
Client Company/Employer
IA006
CITY
Client City
IA007
STATE
Client State
IA008
ZIP
Client Zip Code
IA009
PROV
Client Province
IA010
SCODE
Service Code
!!!
IA011
Service Description
IA012
DAY_HOUR
Billed By Day or By Hour
gv = 'D' .or. gv = 'H'
Enter a D or H Only!
IA013
HOURS
Number of Hours Billed
9999.99
Number of Hours Billed Must Be Greater Than ZERO!
IA014
HRATE
Hourly Rate
Rate Must Be Greater Than ZERO!
IA015
Number of Days Billed
Days Must Be Greater Than ZERO!
IA016
DRATE
Daily Rate
IA017
Invoice Amount
IA018
EXPENSES
Billable Expenses
IA019
PAID
Paid Amount
IA020
PDATE
Date Paid
IA021
IAGE
Age of Receivable in Days
Amount Must Be Greater Than OR Equal to Zero!
IA022
BAL
Balance Due
SA001
SA002
SA003
City
SA004
State
SA005
Zip Code
SA006
Province
SA007
ON1
Contact Date
SA008
TYPE1
Contact Type
SA009
DESC1
Contact Description
SA010
SUBJ
Subject of Contact
SA011
FOLLOW
Requires Follow Up (Y/N)?
SA012
WHEN
SA013
TYPE2
SA014
DESC2
SA015
REPLY
Replied (Y/N)?
SA016
WHEN2
Date Replied
SA017
TYPE3
Type of Reply
SA018
INNAME
In Master Name File (Y/N)?
MA001
MA002
MA003
MA004
MA005
MA006
MA007
Amount
MA008
EXPENSE
Expense Amount
MA009
Amount Paid
MA010
WL001
Task Date
WL002
START
Task Start Time
99:99
WL003
SAMPM
Start Time is AM or PM
gv = 'AM' .or. gv = 'PM'
Must enter AM or PM only!
WL004
END
Task End Time
WL005
EAMPM
End Time AM or PM
Must be AM or PM only!
WL006
Task Description
WL007
NOTES
M
Task Notes
NA017
Notes
AA011
ANOTES
FA012
EA014
CA020
CNOTES
TA007
TNOTES
IA023
SA019
CL001
CLASSNUM
Course Code
!!!9999
CL002
CLASSS
Course Name
CL003
FROM_D
Start Date
CL004
FROM_T
Start Time
CL005
TO_D
End Date
CL006
TO_T
End Time
CL007
FEE
Course Fee
999,999.99
CL008
WHERE
Location
CL009
MAX
Maximum Attendance
CL010
ATTEND
Number Registered
CL011
Status
gv = 'S' .or. gv = 'C' .or. gv = 'X' .or. gv = 'I' .or. gv = 'P'
S=Scheduled  C=Completed  X=Cancelled  I=In Progress  P=Postponed
CL012
RE001
RE002
FIRNAME
First Name
RE003
Company
RE004
TITLE
Title
RE005
ADDR1
Address-1
RE006
ADDR2
Address-2
RE007
RE008
RE009
!!!!!!!!!!
RE010
RE011
BPHONE
Business Phone
(999) 999-9999
RE012
EXT
Extension
#####
RE013
HPHONE
Home Phone
RE014
FAX
Fax
RE015
CLASS
RE016
RE017
RE018
RE019
RE020
RE021
RE022
RE023
REGDATE
Date Registered
RE024
AMTPAID
RE025
HOWPAID
How Paid
gv='C' .or. gv='K' .or. gv='M' .or. gv='R' .or. gv='O'
C=Cash  K=Cash  M=Money Order  R=Charge  O=Other
RE026
CHECKNUM
Check Number
RE027
CHKDATE
Check Date
RE028
CREDIT
Charge Card
gv='M' .or. gv='V' .or. gv='A' .or. gv='D' .or. gv='O'
M=Master Card  V=Visa  A=American Express  D=Discover  O=Optima
RE029
CNUM
Card Number
####-####-####-####
RE030
EXPIRE
Card Expiration
99/99
RE031
RE032
PAID_D
RE033
CANCEL
Cancellation?
gv='Y' .or. gv='N'
Y=Yes  N=No
RE034
CANDATE
Date Cancelled
RE035
Attended?
RE036
EVAL_T
Instructor Evaluation
gv='0' .or. gv='1' .or. gv='2' .or. gv='3' .or. gv='4' .or. gv='5'
0=Unrated  1=Poor  2=Fair  3=Good  4=Very Good  5=Excellent
RE037
EVAL_S
Student Evaluation
RE038
gv='S' .or. gv='C' .or. gv='X' .or. gv='I' .or. gv='P'
RE039
SW001
SHARENUM
Product Code
SW002
SOFTWARE
Software Product
SW003
VERSION
Version Number
SW004
COST
Cost
9,999.99
SW005
SHIPPING
Shipping Cost
SW006
NUMSOLD
Number Sold
999,999
SW007
LANGUAGE
Language Used
SW008
SH001
SH002
SH003
SH004
SH005
SH006
SH007
SH008
SH009
SH010
SH011
SH012
SH013
SH014
SH015
Software Name
SH016
SH017
SH018
REQUEST
Date Requested
SH019
QUAN
Quantity
99,999
SH020
ORDERBY
How Ordered
gv='T' .or. gv='F' .or. gv='L' .or. gv='P' .or. gv='O'
T=Telephone  F=Fax  L=Letter  P=Purchase Order  O=Other
SH021
SH022
Shipping
SH023
TAX
Tax
SH024
TOTAL
Total Amount
SH025
SH026
C=Check  K=Cash  M=Money Order  R=Charge  O=Other
SH027
SH028
SH029
SH030
SH031
Expiration Date
SH032
SH033
SH034
RETURN
Returned?
SH035
RETDATE
Date Returned
SH036
UPGRADE
Upgradeable?
SH037
SHIPDATE
Date Shipped
SH038
bustele1
Business Phone-1
NA018
bustele2
Business Phone-2
NA019
busfax
Business Fax-1
NA020
busfax2
Business Fax-2
NA021
car
Cellular Phone